Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DECIMALS

The DECIMALS option controls the number of decimal places that are shown in numeric output. Values are rounded to fit the specified number of decimal places. (Note, however, that the setting of DECIMALS does not affect the format of INTEGER values in output. INTEGER values are shown with no decimal places, unless you explicitly apply a DECIMAL attribute to them in a HEADING, REPORT, or ROW command.)

Data type

INTEGER

Syntax

DECIMALS = n

Arguments

n

  An `INTEGER` expression that specifies the number of decimal places to include in all output of DECIMAL and SHORTDECIMAL values; n can be any number in the range 0 to 40 or the number 255. (When you set DECIMALS to `255`, you are specifying the formats for values of both SHORTDECIMAL and DECIMAL data types. See "Comparing 2 Decimal Places with Best Presentation Format".) The default is 2.

Examples

Example 10-3 Showing Data with No Decimal Places

To show no decimal places in numeric output, set the DECIMALS option to `0` (zero) before you produce your report.

    DECIMALS = 0
    LIMIT line TO 'COGS'
    LIMIT month TO 'Jan96' 'Feb96'
    REPORT DOWN division ACROSS month: budget

These statements produce the following output.

    LINE: COGS
                   -------BUDGET--------
                   --------MONTH--------
    DIVISION         Jan96      Feb96
    -------------- ---------- ----------
    Camping           355,933    385,308
    Sporting          279,773    323,982
    Clothing          528,370    546,468

Example 10-4 Comparing 2 Decimal Places with Best Presentation Format

This example contrasts the effects of setting DECIMALS to `2` and setting it to `255` ("best presentation" format).

The OLAP DML statements

    DECIMALS = 2
    SHOW JOINCHARS(1.1 'A')

produce the following output.

    1.10A

The OLAP DML statements

    DECIMALS = 255
    SHOW JOINCHARS(1.1 'A')

produce the following output.

    1.1A